Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 57793 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 37 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 7.1 MiB |
| Average record size in memory | 128.0 B |
Variable types
| NUM | 12 |
|---|---|
| CAT | 4 |
Reproduction
| Analysis started | 2020-08-23 14:01:22.448072 |
|---|---|
| Analysis finished | 2020-08-23 14:04:56.782598 |
| Duration | 3 minutes and 34.33 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
| Dataset has 37 (0.1%) duplicate rows | Duplicates |
country_full has a high cardinality: 216 distinct values | High cardinality |
country_abrv has a high cardinality: 216 distinct values | High cardinality |
rank_date has a high cardinality: 286 distinct values | High cardinality |
cur_year_avg is highly correlated with total_points and 1 other fields | High correlation |
total_points is highly correlated with cur_year_avg and 7 other fields | High correlation |
cur_year_avg_weighted is highly correlated with total_points and 1 other fields | High correlation |
last_year_avg is highly correlated with total_points and 1 other fields | High correlation |
last_year_avg_weighted is highly correlated with total_points and 1 other fields | High correlation |
two_year_ago_avg is highly correlated with total_points and 1 other fields | High correlation |
two_year_ago_weighted is highly correlated with total_points and 1 other fields | High correlation |
three_year_ago_avg is highly correlated with total_points and 1 other fields | High correlation |
three_year_ago_weighted is highly correlated with total_points and 1 other fields | High correlation |
rank_date is uniformly distributed | Uniform |
total_points has 40712 (70.4%) zeros | Zeros |
previous_points has 1380 (2.4%) zeros | Zeros |
rank_change has 15453 (26.7%) zeros | Zeros |
cur_year_avg has 42516 (73.6%) zeros | Zeros |
cur_year_avg_weighted has 42516 (73.6%) zeros | Zeros |
last_year_avg has 42634 (73.8%) zeros | Zeros |
last_year_avg_weighted has 42634 (73.8%) zeros | Zeros |
two_year_ago_avg has 42881 (74.2%) zeros | Zeros |
two_year_ago_weighted has 42881 (74.2%) zeros | Zeros |
three_year_ago_avg has 42930 (74.3%) zeros | Zeros |
three_year_ago_weighted has 42930 (74.3%) zeros | Zeros |
rank
Real number (ℝ≥0)
| Distinct count | 209 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.62808644645546 |
|---|---|
| Minimum | 1 |
| Maximum | 209 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 51 |
| median | 101 |
| Q3 | 152 |
| 95-th percentile | 194 |
| Maximum | 209 |
| Range | 208 |
| Interquartile range (IQR) | 101 |
Descriptive statistics
| Standard deviation | 58.61842434 |
|---|---|
| Coefficient of variation (CV) | 0.5767935459 |
| Kurtosis | -1.179510343 |
| Mean | 101.6280864 |
| Median Absolute Deviation (MAD) | 50 |
| Skewness | 0.01822593373 |
| Sum | 5873392 |
| Variance | 3436.119672 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 147 | 303 | 0.5% | |
| 120 | 301 | 0.5% | |
| 112 | 301 | 0.5% | |
| 199 | 300 | 0.5% | |
| 153 | 299 | 0.5% | |
| 129 | 299 | 0.5% | |
| 133 | 298 | 0.5% | |
| 151 | 298 | 0.5% | |
| 156 | 298 | 0.5% | |
| 59 | 297 | 0.5% | |
| Other values (199) | 54799 | 94.8% |
| Value | Count | Frequency (%) | |
| 1 | 286 | 0.5% | |
| 2 | 287 | 0.5% | |
| 3 | 285 | 0.5% | |
| 4 | 290 | 0.5% | |
| 5 | 290 | 0.5% |
| Value | Count | Frequency (%) | |
| 209 | 9 | < 0.1% | |
| 208 | 19 | < 0.1% | |
| 207 | 89 | 0.2% | |
| 206 | 138 | 0.2% | |
| 205 | 160 | 0.3% |
| Distinct count | 216 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 451.5 KiB |
| Sudan | 325 |
|---|---|
| Costa Rica | 286 |
| Iceland | 286 |
| Singapore | 286 |
| Belarus | 286 |
| Other values (211) |
| Value | Count | Frequency (%) | |
| Sudan | 325 | 0.6% | |
| Costa Rica | 286 | 0.5% | |
| Iceland | 286 | 0.5% | |
| Singapore | 286 | 0.5% | |
| Belarus | 286 | 0.5% | |
| Malawi | 286 | 0.5% | |
| Australia | 286 | 0.5% | |
| Finland | 286 | 0.5% | |
| Malta | 286 | 0.5% | |
| Uruguay | 286 | 0.5% | |
| Other values (206) | 54894 | 95.0% |
Length
| Max length | 29 |
|---|---|
| Median length | 7 |
| Mean length | 8.72109079 |
| Min length | 3 |
| Distinct count | 216 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 451.5 KiB |
| SDN | 325 |
|---|---|
| TUR | 286 |
| YEM | 286 |
| SIN | 286 |
| LBY | 286 |
| Other values (211) |
| Value | Count | Frequency (%) | |
| SDN | 325 | 0.6% | |
| TUR | 286 | 0.5% | |
| YEM | 286 | 0.5% | |
| SIN | 286 | 0.5% | |
| LBY | 286 | 0.5% | |
| ITA | 286 | 0.5% | |
| PUR | 286 | 0.5% | |
| BEN | 286 | 0.5% | |
| ISL | 286 | 0.5% | |
| PRK | 286 | 0.5% | |
| Other values (206) | 54894 | 95.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 11114 |
|---|---|
| Unique (%) | 19.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 122.06863685913518 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1775.03 |
| Zeros | 40712 |
| Zeros (%) | 70.4% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 92.79 |
| 95-th percentile | 730.084 |
| Maximum | 1775.03 |
| Range | 1775.03 |
| Interquartile range (IQR) | 92.79 |
Descriptive statistics
| Standard deviation | 260.4268632 |
|---|---|
| Coefficient of variation (CV) | 2.133446149 |
| Kurtosis | 6.893278156 |
| Mean | 122.0686369 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.587571993 |
| Sum | 7054712.73 |
| Variance | 67822.15108 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 40712 | 70.4% | |
| 63.75 | 48 | 0.1% | |
| 38.25 | 39 | 0.1% | |
| 66 | 33 | 0.1% | |
| 127.5 | 31 | 0.1% | |
| 33 | 31 | 0.1% | |
| 4.3 | 26 | < 0.1% | |
| 25.8 | 24 | < 0.1% | |
| 29.75 | 23 | < 0.1% | |
| 51.6 | 22 | < 0.1% | |
| Other values (11104) | 16804 | 29.1% |
| Value | Count | Frequency (%) | |
| 0 | 40712 | 70.4% | |
| 1.47 | 3 | < 0.1% | |
| 1.7 | 12 | < 0.1% | |
| 1.76 | 9 | < 0.1% | |
| 2.2 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1775.03 | 1 | < 0.1% | |
| 1770.06 | 1 | < 0.1% | |
| 1765.05 | 1 | < 0.1% | |
| 1735.72 | 1 | < 0.1% | |
| 1728.78 | 1 | < 0.1% |
| Distinct count | 1557 |
|---|---|
| Unique (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 332.30292595989135 |
|---|---|
| Minimum | 0 |
| Maximum | 1920 |
| Zeros | 1380 |
| Zeros (%) | 2.4% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 56 |
| median | 272 |
| Q3 | 525 |
| 95-th percentile | 882 |
| Maximum | 1920 |
| Range | 1920 |
| Interquartile range (IQR) | 469 |
Descriptive statistics
| Standard deviation | 302.8729476 |
|---|---|
| Coefficient of variation (CV) | 0.9114362948 |
| Kurtosis | 1.309953598 |
| Mean | 332.302926 |
| Median Absolute Deviation (MAD) | 225 |
| Skewness | 1.09826437 |
| Sum | 19204783 |
| Variance | 91732.02239 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 1380 | 2.4% | |
| 6 | 351 | 0.6% | |
| 11 | 340 | 0.6% | |
| 8 | 330 | 0.6% | |
| 17 | 319 | 0.6% | |
| 4 | 318 | 0.6% | |
| 13 | 318 | 0.6% | |
| 3 | 317 | 0.5% | |
| 7 | 305 | 0.5% | |
| 33 | 301 | 0.5% | |
| Other values (1547) | 53514 | 92.6% |
| Value | Count | Frequency (%) | |
| 0 | 1380 | 2.4% | |
| 1 | 251 | 0.4% | |
| 2 | 251 | 0.4% | |
| 3 | 317 | 0.5% | |
| 4 | 318 | 0.6% |
| Value | Count | Frequency (%) | |
| 1920 | 1 | < 0.1% | |
| 1887 | 3 | < 0.1% | |
| 1883 | 2 | < 0.1% | |
| 1881 | 1 | < 0.1% | |
| 1880 | 1 | < 0.1% |
| Distinct count | 121 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.009897392417766857 |
|---|---|
| Minimum | -72 |
| Maximum | 92 |
| Zeros | 15453 |
| Zeros (%) | 26.7% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | -72 |
|---|---|
| 5-th percentile | -7 |
| Q1 | -2 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 8 |
| Maximum | 92 |
| Range | 164 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 5.804308534 |
|---|---|
| Coefficient of variation (CV) | -586.4482572 |
| Kurtosis | 19.65192743 |
| Mean | -0.009897392418 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.237196204 |
| Sum | -572 |
| Variance | 33.68999755 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 15453 | 26.7% | |
| -1 | 8036 | 13.9% | |
| 1 | 5894 | 10.2% | |
| -2 | 4921 | 8.5% | |
| 2 | 3228 | 5.6% | |
| -3 | 3122 | 5.4% | |
| 3 | 2075 | 3.6% | |
| -4 | 1948 | 3.4% | |
| 4 | 1481 | 2.6% | |
| -5 | 1265 | 2.2% | |
| Other values (111) | 10370 | 17.9% |
| Value | Count | Frequency (%) | |
| -72 | 1 | < 0.1% | |
| -62 | 1 | < 0.1% | |
| -53 | 2 | < 0.1% | |
| -52 | 1 | < 0.1% | |
| -50 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 92 | 1 | < 0.1% | |
| 82 | 1 | < 0.1% | |
| 77 | 1 | < 0.1% | |
| 73 | 1 | < 0.1% | |
| 72 | 1 | < 0.1% |
| Distinct count | 7419 |
|---|---|
| Unique (%) | 12.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.798602252867994 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1158.66 |
| Zeros | 42516 |
| Zeros (%) | 73.6% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 32.25 |
| 95-th percentile | 380.126 |
| Maximum | 1158.66 |
| Range | 1158.66 |
| Interquartile range (IQR) | 32.25 |
Descriptive statistics
| Standard deviation | 138.0148829 |
|---|---|
| Coefficient of variation (CV) | 2.233301043 |
| Kurtosis | 8.44786737 |
| Mean | 61.79860225 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.78375619 |
| Sum | 3571526.62 |
| Variance | 19048.10789 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 42516 | 73.6% | |
| 21.25 | 85 | 0.1% | |
| 63.75 | 78 | 0.1% | |
| 42.5 | 56 | 0.1% | |
| 66 | 55 | 0.1% | |
| 85 | 54 | 0.1% | |
| 34 | 51 | 0.1% | |
| 64.5 | 50 | 0.1% | |
| 127.5 | 50 | 0.1% | |
| 25.5 | 48 | 0.1% | |
| Other values (7409) | 14750 | 25.5% |
| Value | Count | Frequency (%) | |
| 0 | 42516 | 73.6% | |
| 3.86 | 5 | < 0.1% | |
| 4.25 | 2 | < 0.1% | |
| 4.72 | 1 | < 0.1% | |
| 6.07 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1158.66 | 1 | < 0.1% | |
| 1153.12 | 1 | < 0.1% | |
| 1126.04 | 1 | < 0.1% | |
| 1112.98 | 2 | < 0.1% | |
| 1090.54 | 4 | < 0.1% |
| Distinct count | 7419 |
|---|---|
| Unique (%) | 12.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.798602252867994 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1158.66 |
| Zeros | 42516 |
| Zeros (%) | 73.6% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 32.25 |
| 95-th percentile | 380.126 |
| Maximum | 1158.66 |
| Range | 1158.66 |
| Interquartile range (IQR) | 32.25 |
Descriptive statistics
| Standard deviation | 138.0148829 |
|---|---|
| Coefficient of variation (CV) | 2.233301043 |
| Kurtosis | 8.44786737 |
| Mean | 61.79860225 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.78375619 |
| Sum | 3571526.62 |
| Variance | 19048.10789 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 42516 | 73.6% | |
| 21.25 | 85 | 0.1% | |
| 63.75 | 78 | 0.1% | |
| 42.5 | 56 | 0.1% | |
| 66 | 55 | 0.1% | |
| 85 | 54 | 0.1% | |
| 34 | 51 | 0.1% | |
| 64.5 | 50 | 0.1% | |
| 127.5 | 50 | 0.1% | |
| 25.5 | 48 | 0.1% | |
| Other values (7409) | 14750 | 25.5% |
| Value | Count | Frequency (%) | |
| 0 | 42516 | 73.6% | |
| 3.86 | 5 | < 0.1% | |
| 4.25 | 2 | < 0.1% | |
| 4.72 | 1 | < 0.1% | |
| 6.07 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1158.66 | 1 | < 0.1% | |
| 1153.12 | 1 | < 0.1% | |
| 1126.04 | 1 | < 0.1% | |
| 1112.98 | 2 | < 0.1% | |
| 1090.54 | 4 | < 0.1% |
| Distinct count | 7473 |
|---|---|
| Unique (%) | 12.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.00460228747426 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1169.57 |
| Zeros | 42634 |
| Zeros (%) | 73.8% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 26.66 |
| 95-th percentile | 372.624 |
| Maximum | 1169.57 |
| Range | 1169.57 |
| Interquartile range (IQR) | 26.66 |
Descriptive statistics
| Standard deviation | 137.6882037 |
|---|---|
| Coefficient of variation (CV) | 2.257013382 |
| Kurtosis | 9.397350184 |
| Mean | 61.00460229 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.881456975 |
| Sum | 3525638.98 |
| Variance | 18958.04145 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 42634 | 73.8% | |
| 66 | 79 | 0.1% | |
| 21.25 | 69 | 0.1% | |
| 63.75 | 62 | 0.1% | |
| 26.4 | 57 | 0.1% | |
| 64.5 | 53 | 0.1% | |
| 25.8 | 52 | 0.1% | |
| 127.5 | 50 | 0.1% | |
| 42.5 | 46 | 0.1% | |
| 85 | 45 | 0.1% | |
| Other values (7463) | 14646 | 25.3% |
| Value | Count | Frequency (%) | |
| 0 | 42634 | 73.8% | |
| 3.86 | 5 | < 0.1% | |
| 4.25 | 2 | < 0.1% | |
| 5.83 | 1 | < 0.1% | |
| 6.07 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1169.57 | 1 | < 0.1% | |
| 1159.71 | 1 | < 0.1% | |
| 1158.66 | 1 | < 0.1% | |
| 1153.12 | 1 | < 0.1% | |
| 1112.98 | 1 | < 0.1% |
| Distinct count | 7001 |
|---|---|
| Unique (%) | 12.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.502377450556295 |
|---|---|
| Minimum | 0.0 |
| Maximum | 584.79 |
| Zeros | 42634 |
| Zeros (%) | 73.8% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 13.33 |
| 95-th percentile | 186.312 |
| Maximum | 584.79 |
| Range | 584.79 |
| Interquartile range (IQR) | 13.33 |
Descriptive statistics
| Standard deviation | 68.84414345 |
|---|---|
| Coefficient of variation (CV) | 2.257009099 |
| Kurtosis | 9.397297397 |
| Mean | 30.50237745 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.881449511 |
| Sum | 1762823.9 |
| Variance | 4739.516088 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 42634 | 73.8% | |
| 33 | 79 | 0.1% | |
| 10.63 | 69 | 0.1% | |
| 31.88 | 62 | 0.1% | |
| 13.2 | 57 | 0.1% | |
| 32.25 | 53 | 0.1% | |
| 12.9 | 52 | 0.1% | |
| 63.75 | 50 | 0.1% | |
| 21.25 | 46 | 0.1% | |
| 17 | 45 | 0.1% | |
| Other values (6991) | 14646 | 25.3% |
| Value | Count | Frequency (%) | |
| 0 | 42634 | 73.8% | |
| 1.93 | 5 | < 0.1% | |
| 2.13 | 2 | < 0.1% | |
| 2.91 | 1 | < 0.1% | |
| 3.04 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 584.79 | 1 | < 0.1% | |
| 579.85 | 1 | < 0.1% | |
| 579.33 | 1 | < 0.1% | |
| 576.56 | 1 | < 0.1% | |
| 556.49 | 1 | < 0.1% |
| Distinct count | 7575 |
|---|---|
| Unique (%) | 13.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59.77746214939526 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1159.71 |
| Zeros | 42881 |
| Zeros (%) | 74.2% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 21.5 |
| 95-th percentile | 377.23 |
| Maximum | 1159.71 |
| Range | 1159.71 |
| Interquartile range (IQR) | 21.5 |
Descriptive statistics
| Standard deviation | 136.2960787 |
|---|---|
| Coefficient of variation (CV) | 2.280057966 |
| Kurtosis | 9.346097184 |
| Mean | 59.77746215 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.879949855 |
| Sum | 3454718.87 |
| Variance | 18576.62108 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 42881 | 74.2% | |
| 66 | 78 | 0.1% | |
| 21.25 | 76 | 0.1% | |
| 25.5 | 70 | 0.1% | |
| 8.5 | 68 | 0.1% | |
| 34 | 67 | 0.1% | |
| 26.4 | 55 | 0.1% | |
| 64.5 | 54 | 0.1% | |
| 25.8 | 51 | 0.1% | |
| 42.5 | 47 | 0.1% | |
| Other values (7565) | 14346 | 24.8% |
| Value | Count | Frequency (%) | |
| 0 | 42881 | 74.2% | |
| 6.14 | 4 | < 0.1% | |
| 7.08 | 3 | < 0.1% | |
| 7.17 | 3 | < 0.1% | |
| 7.33 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1159.71 | 1 | < 0.1% | |
| 1158.66 | 1 | < 0.1% | |
| 1153.12 | 1 | < 0.1% | |
| 1126.04 | 1 | < 0.1% | |
| 1112.98 | 2 | < 0.1% |
| Distinct count | 6513 |
|---|---|
| Unique (%) | 11.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.933277386534705 |
|---|---|
| Minimum | 0.0 |
| Maximum | 347.91 |
| Zeros | 42881 |
| Zeros (%) | 74.2% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 6.45 |
| 95-th percentile | 113.17 |
| Maximum | 347.91 |
| Range | 347.91 |
| Interquartile range (IQR) | 6.45 |
Descriptive statistics
| Standard deviation | 40.8888489 |
|---|---|
| Coefficient of variation (CV) | 2.28005445 |
| Kurtosis | 9.346066533 |
| Mean | 17.93327739 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.879945895 |
| Sum | 1036417.9 |
| Variance | 1671.897964 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 42881 | 74.2% | |
| 19.8 | 78 | 0.1% | |
| 6.38 | 76 | 0.1% | |
| 7.65 | 70 | 0.1% | |
| 2.55 | 68 | 0.1% | |
| 10.2 | 67 | 0.1% | |
| 7.92 | 55 | 0.1% | |
| 19.35 | 54 | 0.1% | |
| 7.74 | 51 | 0.1% | |
| 12.75 | 47 | 0.1% | |
| Other values (6503) | 14346 | 24.8% |
| Value | Count | Frequency (%) | |
| 0 | 42881 | 74.2% | |
| 1.84 | 4 | < 0.1% | |
| 2.12 | 3 | < 0.1% | |
| 2.15 | 3 | < 0.1% | |
| 2.2 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 347.91 | 1 | < 0.1% | |
| 347.6 | 1 | < 0.1% | |
| 345.94 | 1 | < 0.1% | |
| 337.81 | 1 | < 0.1% | |
| 333.89 | 2 | < 0.1% |
| Distinct count | 7628 |
|---|---|
| Unique (%) | 13.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59.173916391258466 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1200.77 |
| Zeros | 42930 |
| Zeros (%) | 74.3% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 21.25 |
| 95-th percentile | 372.844 |
| Maximum | 1200.77 |
| Range | 1200.77 |
| Interquartile range (IQR) | 21.25 |
Descriptive statistics
| Standard deviation | 135.5333429 |
|---|---|
| Coefficient of variation (CV) | 2.290423741 |
| Kurtosis | 9.696436119 |
| Mean | 59.17391639 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.909801534 |
| Sum | 3419838.15 |
| Variance | 18369.28705 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 42930 | 74.3% | |
| 8.5 | 72 | 0.1% | |
| 25.5 | 72 | 0.1% | |
| 66 | 71 | 0.1% | |
| 34 | 69 | 0.1% | |
| 21.25 | 63 | 0.1% | |
| 42.5 | 62 | 0.1% | |
| 26.4 | 56 | 0.1% | |
| 25.8 | 54 | 0.1% | |
| 64.5 | 52 | 0.1% | |
| Other values (7618) | 14292 | 24.7% |
| Value | Count | Frequency (%) | |
| 0 | 42930 | 74.3% | |
| 5.83 | 1 | < 0.1% | |
| 6.14 | 4 | < 0.1% | |
| 6.31 | 1 | < 0.1% | |
| 7.08 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1200.77 | 1 | < 0.1% | |
| 1158.66 | 1 | < 0.1% | |
| 1136.57 | 1 | < 0.1% | |
| 1126.04 | 1 | < 0.1% | |
| 1119.11 | 1 | < 0.1% |
| Distinct count | 5849 |
|---|---|
| Unique (%) | 10.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.834811136296786 |
|---|---|
| Minimum | 0.0 |
| Maximum | 240.15 |
| Zeros | 42930 |
| Zeros (%) | 74.3% |
| Memory size | 451.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4.25 |
| 95-th percentile | 74.568 |
| Maximum | 240.15 |
| Range | 240.15 |
| Interquartile range (IQR) | 4.25 |
Descriptive statistics
| Standard deviation | 27.10667505 |
|---|---|
| Coefficient of variation (CV) | 2.290418896 |
| Kurtosis | 9.696365035 |
| Mean | 11.83481114 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.909793556 |
| Sum | 683969.24 |
| Variance | 734.7718325 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 42930 | 74.3% | |
| 1.7 | 72 | 0.1% | |
| 5.1 | 72 | 0.1% | |
| 13.2 | 71 | 0.1% | |
| 6.8 | 69 | 0.1% | |
| 4.25 | 63 | 0.1% | |
| 8.5 | 62 | 0.1% | |
| 5.28 | 56 | 0.1% | |
| 5.16 | 54 | 0.1% | |
| 12.9 | 52 | 0.1% | |
| Other values (5839) | 14292 | 24.7% |
| Value | Count | Frequency (%) | |
| 0 | 42930 | 74.3% | |
| 1.17 | 1 | < 0.1% | |
| 1.23 | 4 | < 0.1% | |
| 1.26 | 1 | < 0.1% | |
| 1.42 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 240.15 | 1 | < 0.1% | |
| 231.73 | 1 | < 0.1% | |
| 227.31 | 1 | < 0.1% | |
| 225.21 | 1 | < 0.1% | |
| 223.82 | 1 | < 0.1% |
confederation
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 451.5 KiB |
| UEFA | |
|---|---|
| CAF | |
| AFC | |
| CONCACAF | |
| CONMEBOL | 2860 |
| Value | Count | Frequency (%) | |
| UEFA | 14933 | 25.8% | |
| CAF | 14876 | 25.7% | |
| AFC | 12617 | 21.8% | |
| CONCACAF | 9664 | 16.7% | |
| CONMEBOL | 2860 | 4.9% | |
| OFC | 2843 | 4.9% |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 4.34190992 |
| Min length | 3 |
| Distinct count | 286 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 451.5 KiB |
| 2018-06-07 | 211 |
|---|---|
| 2016-11-24 | 211 |
| 2016-10-20 | 211 |
| 2017-12-21 | 211 |
| 2017-03-09 | 211 |
| Other values (281) |
| Value | Count | Frequency (%) | |
| 2018-06-07 | 211 | 0.4% | |
| 2016-11-24 | 211 | 0.4% | |
| 2016-10-20 | 211 | 0.4% | |
| 2017-12-21 | 211 | 0.4% | |
| 2017-03-09 | 211 | 0.4% | |
| 2017-10-16 | 211 | 0.4% | |
| 2017-02-09 | 211 | 0.4% | |
| 2017-06-01 | 211 | 0.4% | |
| 2018-02-15 | 211 | 0.4% | |
| 2016-12-22 | 211 | 0.4% | |
| Other values (276) | 55683 | 96.3% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| rank | country_full | country_abrv | total_points | previous_points | rank_change | cur_year_avg | cur_year_avg_weighted | last_year_avg | last_year_avg_weighted | two_year_ago_avg | two_year_ago_weighted | three_year_ago_avg | three_year_ago_weighted | confederation | rank_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | Germany | GER | 0.0 | 57 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | UEFA | 1993-08-08 |
| 1 | 2 | Italy | ITA | 0.0 | 57 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | UEFA | 1993-08-08 |
| 2 | 3 | Switzerland | SUI | 0.0 | 50 | 9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | UEFA | 1993-08-08 |
| 3 | 4 | Sweden | SWE | 0.0 | 55 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | UEFA | 1993-08-08 |
| 4 | 5 | Argentina | ARG | 0.0 | 51 | 5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | CONMEBOL | 1993-08-08 |
| 5 | 6 | Republic of Ireland | IRL | 0.0 | 54 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | UEFA | 1993-08-08 |
| 6 | 7 | Russia | RUS | 0.0 | 52 | 1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | UEFA | 1993-08-08 |
| 7 | 8 | Brazil | BRA | 0.0 | 55 | -5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | CONMEBOL | 1993-08-08 |
| 8 | 9 | Norway | NOR | 0.0 | 49 | 5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | UEFA | 1993-08-08 |
| 9 | 10 | Denmark | DEN | 0.0 | 51 | -1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | UEFA | 1993-08-08 |
Last rows
| rank | country_full | country_abrv | total_points | previous_points | rank_change | cur_year_avg | cur_year_avg_weighted | last_year_avg | last_year_avg_weighted | two_year_ago_avg | two_year_ago_weighted | three_year_ago_avg | three_year_ago_weighted | confederation | rank_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57783 | 202 | Cayman Islands | CAY | 8.50 | 9 | 2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 42.50 | 8.50 | CONCACAF | 2018-06-07 |
| 57784 | 203 | San Marino | SMR | 7.92 | 8 | 2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 39.60 | 7.92 | UEFA | 2018-06-07 |
| 57785 | 204 | British Virgin Islands | VGB | 4.25 | 4 | 2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 21.25 | 4.25 | CONCACAF | 2018-06-07 |
| 57786 | 204 | Montserrat | MSR | 4.25 | 17 | -4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 21.25 | 4.25 | CONCACAF | 2018-06-07 |
| 57787 | 206 | Turks and Caicos Islands | TCA | 0.00 | 13 | -4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | CONCACAF | 2018-06-07 |
| 57788 | 206 | Anguilla | AIA | 0.00 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | CONCACAF | 2018-06-07 |
| 57789 | 206 | Bahamas | BAH | 0.00 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | CONCACAF | 2018-06-07 |
| 57790 | 206 | Eritrea | ERI | 0.00 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | CAF | 2018-06-07 |
| 57791 | 206 | Somalia | SOM | 0.00 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | CAF | 2018-06-07 |
| 57792 | 206 | Tonga | TGA | 0.00 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | OFC | 2018-06-07 |
Most frequent
| rank | country_full | country_abrv | total_points | previous_points | rank_change | cur_year_avg | cur_year_avg_weighted | last_year_avg | last_year_avg_weighted | two_year_ago_avg | two_year_ago_weighted | three_year_ago_avg | three_year_ago_weighted | confederation | rank_date | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 100 | Sudan | SDN | 350.66 | 332 | 3 | 186.58 | 186.58 | 187.77 | 93.88 | 129.76 | 38.93 | 156.36 | 31.27 | CAF | 2012-10-03 | 2 |
| 1 | 100 | Sudan | SDN | 361.33 | 349 | 1 | 243.75 | 243.75 | 120.92 | 60.46 | 163.12 | 48.94 | 40.91 | 8.18 | CAF | 2013-01-17 | 2 |
| 2 | 101 | Sudan | SDN | 338.25 | 292 | 12 | 179.70 | 179.70 | 209.32 | 104.66 | 7.08 | 2.12 | 258.83 | 51.77 | CAF | 2012-06-06 | 2 |
| 3 | 101 | Sudan | SDN | 348.90 | 333 | 1 | 206.25 | 206.25 | 126.55 | 63.27 | 219.72 | 65.91 | 67.36 | 13.47 | CAF | 2012-12-19 | 2 |
| 4 | 102 | Sudan | SDN | 333.08 | 351 | -2 | 178.47 | 178.47 | 155.52 | 77.76 | 207.16 | 62.15 | 73.49 | 14.70 | CAF | 2012-11-07 | 2 |
| 5 | 103 | Sudan | SDN | 331.79 | 329 | 1 | 169.05 | 169.05 | 187.77 | 93.88 | 108.13 | 32.44 | 182.11 | 36.42 | CAF | 2012-09-05 | 2 |
| 6 | 104 | Sudan | SDN | 329.36 | 329 | 1 | 171.57 | 171.57 | 229.19 | 114.60 | 8.50 | 2.55 | 203.22 | 40.64 | CAF | 2012-08-08 | 2 |
| 7 | 104 | Sudan | SDN | 343.15 | 361 | -4 | 207.86 | 207.86 | 156.34 | 78.17 | 163.12 | 48.94 | 40.91 | 8.18 | CAF | 2013-02-14 | 2 |
| 8 | 105 | Sudan | SDN | 329.36 | 338 | -4 | 171.57 | 171.57 | 229.19 | 114.60 | 8.50 | 2.55 | 203.22 | 40.64 | CAF | 2012-07-04 | 2 |
| 9 | 107 | Sudan | SDN | 297.62 | 221 | 26 | 196.28 | 196.28 | 60.32 | 30.16 | 133.60 | 40.08 | 155.52 | 31.10 | CAF | 2014-10-23 | 2 |